DatePart(datepart, date)


Returns the specified part of a date as an integer.

See also DateAdd and DateConvert.

datepart

One of the following strings:

• yyyy -- Year
• q -- Quarter
• m -- Month
• y -- Day of year
• d -- Day
• w -- Weekday
• ww -- Week
• h -- Hour
• n -- Minute
• s -- Second

date

Any date.